Protected: Valuation and Financial Modeling – Dallas Bootcamp (June 30th – July 2nd, 2025)

Participants in this 3-day bootcamp will be learn the foundations of accounting, finance, valuation and financial modeling.  This immersive experience will be a mix of theory and practical applications.  Participants will construct analysis and a deeper understanding of how to effectively leverage Microsoft Excel for their work. Day 1: Accounting and Finance Foundations: Accounting fundamentals Overview and components of the Income Statement, Balance Sheet and Cash Flow Statement Golden Rule of Accounting: Assets = Liabilities + Equity 3-Statement connectivity Overview of the links across the income statement, balance sheet and cash flow statement. Non-GAAP items: Importance of EBIT and EBITDA Discussion of differences between EBITDA and actual cash flows Calculating key ratios (margins, growth rates, leverage and coverage ratios) Working capital analysis – cash conversion cycle Discussion of: Accounts receivable days Inventory days Accounts payable days Intangible assets overview Definite Life Intangibles Indefinite Life Intangibles Goodwill Debt and Interest Overview Types of debt tranches (senior debt, subordinated debt) Calculation of interest expense (cash and PIK) for financial modeling purposes Careers in Finance: Introduction to investment banking, private equity / hedge funds Day 2: Overview of Corporate Valuation Excel Shortcuts and Efficiencies Introduction to Corporate Valuation: Overview of Valuation Methodologies Discussion of Enterprise Value vs. Equity Value Discussion of Enterprise Value vs. Equity Value multiples Excel shortcuts, efficiencies and best practices Navigating shortcuts Proper number formatting (dollar amounts, per share amounts, share counts, multiples and percentages). Proper font color formatting (inputs, references to other sheets, calculations). Proper borders (top borders, right borders) Copy and pasting options CTRL+C / CTRL+V Paste Special Options Introduction to Financial Modeling Day 3: Constructing a Discounted Cash Flows Model and Data Manipulation Overview and construction of a Discounted Cash Flows analysis Strengths and considerations of the DCF analysis Calculating unlevered free cash flows Identifying key drivers and data points from SEC filings and management guidance Calculating a discount rate (weighted average cost of capital) Discounting unlevered free cash flows Excel Functionality / Data Manipulation Text Functions LOOKUPS, INDEX / MATCH SUMIFS / COUNTIFS Pivot Tables Logistics: The course will take place in the June 30th - July 2nd. Daily Timings: 10:00 a.m. - 3:00 p.m. CST Participants will receive an email with course files prior to the course. No need to work on any of the files in advance, everything will be covered during the course. Course Takeaways: Participants will Receive: Key SEC filings, management presentations and press releases utilized for the historical metrics and projections. Excel template and instructor solution files Listing of the top Excel keyboard shortcuts Access to a Zoom recording of the bootcamp